UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b8pEmRY07v9TlLJ0Z89Fe7wstLCY8lEgSZ40IpvJqIk='
WHERE
key_id = '78ec25cb1c0bb932175ed8a98e599a2bb5c3de7c0574d1a9882a3f4c8428fecb'
AND (
token = 'b8pEmRY07v9TlLJ0Z89Fe7wstLCY8lEgSZ40IpvJqIk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)