UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qTPuTRqDBF8Npi8E4TMDHO36a5QC3QVsCexWBcuIAFs='
WHERE
key_id = '7e0d13ffce037a2058c7b313f5618f4e563b91ff78b1d7d3bd699d8c9afdf7b2'
AND (
token = 'qTPuTRqDBF8Npi8E4TMDHO36a5QC3QVsCexWBcuIAFs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)