UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3ZG5FobJ4KvJM/NFOdTmGgoj357IIAc5P0TySGYL/Hc=' 
WHERE 
  key_id = '42e3fc605ba4cac7c86cb0a1626f0f07696f655d11b17fd87ff5dba430c6a959' 
  AND (
    token = '3ZG5FobJ4KvJM/NFOdTmGgoj357IIAc5P0TySGYL/Hc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028