UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'FEC7kftUKNjvy8r4AbBJiD7W4oAZNmIi5B7Nj0PZ/RQ=' 
WHERE 
  key_id = 'a73f62212da4181bf6b2596f62851c77d6476586833f815ad07c423ae9add4fb' 
  AND (
    token = 'FEC7kftUKNjvy8r4AbBJiD7W4oAZNmIi5B7Nj0PZ/RQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024