UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9oMuy0JEz84oOZDRfw/oMv8Tyzj74jLmAdmUJC2qIXA='
WHERE
key_id = '180e30490b903790303b3ad5e59299e4f154938de8528dce06dfdd7b0ed4da87'
AND (
token = '9oMuy0JEz84oOZDRfw/oMv8Tyzj74jLmAdmUJC2qIXA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)