SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'd5deaf0f526424606141d79b4917efa189be2c12b441fa79d6c644f31e50b66f' 
  AND token = 'Vzsm7hzmCPJtTbMLosy826NQHfNxH6vfVBX/AXZrEcA=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

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