UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nQ0scsMS3cmPH1NMaAh/LXvFapYOJ9/aDnyJQpAtyxU='
WHERE
key_id = '8f6312a1d94554a86ad42495bf3733369e4c75c79e6e6b70a62a098976f72d7e'
AND (
token = 'nQ0scsMS3cmPH1NMaAh/LXvFapYOJ9/aDnyJQpAtyxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)