SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '4245ce4246109b5cfa3d85e35ade5041a9ca7b4b9ccd609d11d17b8faa4a8c3b' 
  AND token = 'BPXPEql7JryMFlREhgm7E5PrV6+C1NS7wpJugbfj9O4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00015

JSON explain

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