UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LEA9lgZ3HL5WdByOELLrUF2GyS58hz99bY4hyUsH6q8='
WHERE
key_id = 'c9792b42faf3e1c8e1b4b0bf321e0e90e0be1629167c827efdc4f85a7e5b991f'
AND (
token = 'LEA9lgZ3HL5WdByOELLrUF2GyS58hz99bY4hyUsH6q8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)