UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2wBW0LOs3ejMTUkmlZAhh8lyFgnBqfvDrVkW8NZ3qzo='
WHERE
key_id = '0e5bb866117f985b3419f9cc5a6a7b6f19fc5cdf7e209d1164eeeb98febb5610'
AND (
token = '2wBW0LOs3ejMTUkmlZAhh8lyFgnBqfvDrVkW8NZ3qzo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)