UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JNC/IcKcvXk126SZffmzu2wn4ZFiOid7OAUBU+PhDOc='
WHERE
key_id = '1e7f255ae10494685104cf74835c9fc27ade4065a83e6fbf7a9219a18deb46f0'
AND (
token = 'JNC/IcKcvXk126SZffmzu2wn4ZFiOid7OAUBU+PhDOc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)