UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8b9i75LtuLDHQIQc5xO5ehxbUS1JD1usI4NxggPPans=' 
WHERE 
  key_id = '5168b0200b2b8b45e35da653c3945ccd521bcef8f2f29575e67c348976367f8f' 
  AND (
    token = '8b9i75LtuLDHQIQc5xO5ehxbUS1JD1usI4NxggPPans=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048