UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MxECBNRrKlvm2rDi2EWBVFAnKOU7zPiE/W5C6kBrW/M='
WHERE
key_id = 'a6423ce1c3fbe5e1ced2dc19c261954b14941d2356f71fd3a5ff501dc8dc7294'
AND (
token = 'MxECBNRrKlvm2rDi2EWBVFAnKOU7zPiE/W5C6kBrW/M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)