UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6HfQ3eaJ1NsexdGgWGFRoTRdUEtuJKmPbyrgfKh83mM='
WHERE
key_id = 'b8c9c70f6fd09a9a08f10eaf4720999f8c2923d3e4e5ed2f06288dd288ca0fba'
AND (
token = '6HfQ3eaJ1NsexdGgWGFRoTRdUEtuJKmPbyrgfKh83mM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)