UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0dH1bNamAv26IJLHYyLz+oc7W4iz2I/d5quJV+uAs+I=' 
WHERE 
  key_id = '6db7f628e9b3edeec9ec2b2185c3ce7a7b0543a02f112801592597c8cb80c69a' 
  AND (
    token = '0dH1bNamAv26IJLHYyLz+oc7W4iz2I/d5quJV+uAs+I=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042