UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '66uQZnwnMY9ThtVfF+QnBYgvHLV462fVz/uY2JA8TrU='
WHERE
key_id = 'caab094e66dbf6e97f950d8d3edff47d8f339c35feed5f88e2b08495e732586c'
AND (
token = '66uQZnwnMY9ThtVfF+QnBYgvHLV462fVz/uY2JA8TrU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)