UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cOhoH14NRDW7BhBHK13scTdXW5cMmT48P/oRfJQY2kw='
WHERE
key_id = 'ecb22094493a99240a1aadab6d542f09d3279efd0f5a15b4a343acfb7a4648d7'
AND (
token = 'cOhoH14NRDW7BhBHK13scTdXW5cMmT48P/oRfJQY2kw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)