UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GV8Mf77f9AAz7lLCAFUO4nB3ZEKukMgP28qrlhM203U='
WHERE
key_id = 'b48fce58c8a5dac37c986ee9e361701d35f99c755154ed1bb34c6de6f7c2a4a3'
AND (
token = 'GV8Mf77f9AAz7lLCAFUO4nB3ZEKukMgP28qrlhM203U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)