SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '18e1f741368ee9d2873f8a7e591a3fb6c2c81a36f3ced4107b04623f5c23e9aa' 
  AND token = 'OzA1LVP8vO34NLaOGFhBa05vbllCGRfdFXjPc1fLdds=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00019

JSON explain

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