UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'f4cBCcIQNWRNwX/ssynh6G94LKcQw+YGOVS/jqMjdns=' 
WHERE 
  key_id = 'd40d8505a3466da89e0c73ea071a86f34d435e1b6406a24b9d0644ad6d9425f3' 
  AND (
    token = 'f4cBCcIQNWRNwX/ssynh6G94LKcQw+YGOVS/jqMjdns=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028