SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '0b5357b99a1f190e3879ff8ad1f59a66cad1ab4eb77b821636b59fb80dd5f68a' 
  AND token = 'xSLzU/8S8/ga9HhrjBNG8IiW+u5oK6rnHLzjDaPgc3M=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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