SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '470cee26fbb9a8f626b502ae763577c171de9eb418071290a793c337e90a7fe8' 
  AND token = 'HmK4hlcFuiOtJ6ZkmA2mjkQ6CMvKh7QtFLexc63O0ik=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00026

JSON explain

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