UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4vyLWx+P0Z0sKfT550B+3f94FhS3Ouv4OVFq8GWr22w=' 
WHERE 
  key_id = '3f90d91217b12caf9b42db22f8a6a84cc182cedcda1bd4ba794dc080d1185b1a' 
  AND (
    token = '4vyLWx+P0Z0sKfT550B+3f94FhS3Ouv4OVFq8GWr22w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034