SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '8bec18b25c8e4cb2e77bdf2eac572f29cb33e5045b212f750bb1c5248b4aefb6' 
  AND token = 'TSiUSI7MIv8PCwPOUWw+1iEaIJn/lzC92Zd2hIwXAQM=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00028

JSON explain

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