UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'dXS19K6NMloFKhKS+K8HVggeQ8YxAq0RFxsxrlMSQsw=' 
WHERE 
  key_id = '3f209f45daae9e76dc4e5822a712ec139d6748aa3abfff3e30f3a09220948d7f' 
  AND (
    token = 'dXS19K6NMloFKhKS+K8HVggeQ8YxAq0RFxsxrlMSQsw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039