UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SHKOPjhXfE0WStGxKKF4Hca8wfrQxOc1OoRryWafLJE='
WHERE
key_id = '5f1ddb8429843b199f8eefceaea2252eb55aca4c93143955a9b1abb4747a9896'
AND (
token = 'SHKOPjhXfE0WStGxKKF4Hca8wfrQxOc1OoRryWafLJE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)