SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '96c9944538b867ec8550a12452bd9447b782a08d5fe782a2c26f0f741b19cefa' 
  AND token = '7B1t/jM/YoC3AhngyFm/qErMKTOMHO5rMAr3P24zvE4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00017

JSON explain

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