SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '9bf0ca55dcd48ea307447910d056d1d94c920f7d8340fe0e271c60795122e75e' 
  AND token = 'hGJOHbJt9EEWluFz1b8M7YInkc0FiwMxAbmfGpOjFuM=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00019

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}