UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '00gTzLf8TdFl7Yg2lvuR88I3R26cyE47t9u9A5PYiU4='
WHERE
key_id = 'ccd60a7b7dd3320fa59fb125629af6ad86a2a78d451ba57564b1de01e3b5e561'
AND (
token = '00gTzLf8TdFl7Yg2lvuR88I3R26cyE47t9u9A5PYiU4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)