UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'C1bVdpMhdwIuzxN7e0K8Qr2vf8wccoqdmmup0gGk9NA=' 
WHERE 
  key_id = 'e411fc59a8054f465785d37b25e58f4a8a421b27da1e8a296797b8e2b8fde68c' 
  AND (
    token = 'C1bVdpMhdwIuzxN7e0K8Qr2vf8wccoqdmmup0gGk9NA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034