UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3nolzrWj4fQVcnmgO/4HIUdFVxfB4Pi29oglhF5cJcA='
WHERE
key_id = '5a437b849f8a442f1b78eea36a4ef2212b96d991b618138152249198ad12df70'
AND (
token = '3nolzrWj4fQVcnmgO/4HIUdFVxfB4Pi29oglhF5cJcA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)