UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'wau7FiY5DqIW1GOPzsL8O2wGNew7sk52nDkJFg0vhRE=' 
WHERE 
  key_id = '84108a69a94e45cc8544f490efef1d29c9c15632647ee550f7963f0163d0fa9f' 
  AND (
    token = 'wau7FiY5DqIW1GOPzsL8O2wGNew7sk52nDkJFg0vhRE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00019