UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CjPgDatjWFzi1gwbXd0mHFaDC6rEpzhByofEZE+P07E='
WHERE
key_id = 'af7bc5272a4398e84bdeee94c84cbbbbd21ec170048c369bbcafa61e017d3d1b'
AND (
token = 'CjPgDatjWFzi1gwbXd0mHFaDC6rEpzhByofEZE+P07E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)