SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '4adb7ae88893182c62248016c072c6f7d266b6a5da5056d00226d3f9981b3dec' 
  AND token = 'f5iqoOkUSllAiaMYPjam/Tb+8ZImFO/QMxZz90EevYQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

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