UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K6hpoMkmASnazakXBCesG/r6eTEcjWD6YleUBmYTIqE='
WHERE
key_id = 'c58e6de9e52da0e7869d6b96fa2dc88ae846798a97d888c4b7026ab9a0648364'
AND (
token = 'K6hpoMkmASnazakXBCesG/r6eTEcjWD6YleUBmYTIqE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)